package com.jishuo.nontax.bfc.dao;

import com.jishuo.nontax.bean.vo.AllBillFianceJVO;
import com.jishuo.nontax.bean.vo.CheckDataListDetailVO;
import com.jishuo.nontax.bean.vo.ReconciliationVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author :hanlipeng
 * @description :
 * @create :2022-12-21 15:09:00
 */
@Mapper
public interface BankCheckMapper {

    int findIllActInfoCheckBill(@Param("billnum") String billnum, @Param("paybankdt") String paybankdt);

    List<String> findbackpaybill2(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    int findBackPaybillInfo(@Param("backbillnum") String backbillnum, @Param("paybankdt") String paybankdt);

    List<String> findchargebill1(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    int findchargebillCount(@Param("billnum") String billnum, @Param("paybankdt") String paybankdt);

    int findchargebillIsHandCount(@Param("billnum") String billnum, @Param("paybankdt") String paybankdt);

    List<String> findfisc5(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    int findfiscCheckBill(@Param("billnum") String billnum, @Param("paybankdt") String paybankdt);

    int findPaySpeciCouny(@Param("billnum") String billnum, @Param("paybankdt") String paybankdt);

    List<String> findspecial6(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<String> finddivide7(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<String> findstudent9(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    int findDividePayCount(@Param("dividebillnum") String dividebillnum, @Param("paybankdt") String paybankdt);

    int findstudentBillCount(@Param("payeraccount")String payeraccount, @Param("paybankdt") String paybankdt);

    List<String> findillnoksnoscale10(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    int findillActInfoCount(@Param("billnum") String billnum, @Param("paybankdt") String paybankdt);

    List<String> findillnoksscaledown10(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    List<String> findillnoksscaleup11(String paybankdt);

    List<String> findillscalebill12(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    int findPayScaleBillCheck(@Param("billnum") String billnum, @Param("paybankdt") String paybankdt);

    List<String> findpunish13(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    List<String> findwebpay14(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<String> findbankcheck17(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    int findCantonidByBankID(int bankid);

    int saveCheckDataList(List<AllBillFianceJVO> dto);
    int deleteeCheckDataList(AllBillFianceJVO dto);

    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO1(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO2(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO3(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO4(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO5(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO6(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO7(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO8(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO9(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO10(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO11(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO12(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO13(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO15(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO16(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);
    List<CheckDataListDetailVO> findSendCheckDataListDetailDTO17(@Param("bankid") Long bankid, @Param("paybankdt") String paybankdt);

    /**
     * 单据汇总，对账
     * @param bankid 账号id
     * @param accountcode 账号
     * @param paybankdt 对账日期
     * @return
     */
    ReconciliationVO selectReconciliation(@Param("bankid") Long bankid, @Param("accountcode") String accountcode, @Param("paybankdt") String paybankdt);
    /** 汇总，11 */
    ReconciliationVO selectReconciliation11(@Param("bankid") Long bankid, @Param("accountcode") String accountcode, @Param("paybankdt") String paybankdt);

}
